<?php

$installer = $this;
/* @var $installer Mage_Catalog_Model_Resource_Eav_Mysql4_Setup */

$installer->startSetup();

$installer->run("
DROP TABLE IF EXISTS {$this->getTable('paymentmail/paymentmail')};
CREATE TABLE IF NOT EXISTS {$this->getTable('paymentmail/paymentmail')} (
    `paymentemail_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT,
    `form_type` varchar(100) NOT NULL,
    `login_email` varchar(100) NOT NULL,
    `order_no` varchar(100) NOT NULL,
    `mtcn_no` varchar(100) NOT NULL,
    `from_bank` varchar(100) NOT NULL,
    `to_bank`varchar(100) NOT NULL,
    `sent_amount` varchar(100) NOT NULL,
    `sender_name` varchar(100) NOT NULL,
    `url` varchar(100) NOT NULL,
    `file` varchar(100) NOT NULL,
    `refer_no` varchar(100) NOT NULL,
    `firstname` varchar(100) NOT NULL,
    `lastname` varchar(100) NOT NULL,
    `country` varchar(100) NOT NULL,
    `test_question` varchar(100) NOT NULL,
    `test_answer` varchar(100) NOT NULL,
     PRIMARY KEY ( `paymentemail_id` ) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='paymentemail';

");
$installer->endSetup();

